Data Warehouse Modeler: A CASE Tool for Warehouse Design

نویسندگان

  • Leslie L. Miller
  • Sree Nilakanta
چکیده

Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of operational relational databases. The warehouse designer simply specifies a list of attribute names that will appear in the warehouse, conditions if any are desired, and a description of the operational databases. The tool returns the queries needed to populate the

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Two-warehouse system for non-instantaneous deterioration products with promotional effort and inflation over a finite time horizon

In the current global market, organizations use many promotional tools to increase their sales. One such tool is sales teams’ initiatives or promotional policies, i.e., free gifts, discounts, packaging, etc. This phenomenon motivates the retailer/or buyer to order a large inventory lot so as to take full benefit of promotional policies. In view of this the present paper considers a two-warehous...

متن کامل

Design of data warehouses using metadata

Data warehouses have become an instant phenomenon in many large organizations that deal with massive amounts of information. Drawing on the experiences from the systems development ®eld, we surmise that an effective design tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...

متن کامل

DWPPT: Data Warehouse Performance Prediction Tool

The increasing demands for interactive response time from the users makes query performance one of the central problems of Data warehouse systems today. Performance is an important quality aspect of Data warehouse systems. Predicting the performance of Data warehouse systems during early design stages of their development is significant. Software Performance Engineering(SPE) promotes the idea t...

متن کامل

Conversion from star schema of a data warehouse into its equivalent graph multi dimensional data model: A Conceptual Perspective

This paper proposes the design of Star Schema of a Data Warehouse and conversion to its equivalent Graph based Multi Dimensional Data Model (GMDDM Model). Design of Star Schema facilitates in constructing Graph based Multi Dimensional Data Model. The GMDDM model defines a set of graph based constructs that are used to specify the conceptual level design of Data Warehouse. Data warehouse represe...

متن کامل

A Tool for Data Warehouse Multidimensional Schema Design using Ontology

The data warehouse has become a necessary component for an effective analysis of large businesses. It is widely accepted that the data warehouse must be structured according to the multidimensional model to facilitate OLAP analysis. The two driving force for the design of a multidimensional model are data source and business requirements. In recent years in addition to operational databases, we...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1998